﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="ReportDS" targetNamespace="http://tempuri.org/ReportDS.xsd" xmlns:mstns="http://tempuri.org/ReportDS.xsd" xmlns="http://tempuri.org/ReportDS.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="UcConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Public" Name="UcConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.UCENTRIK.Properties.Settings.GlobalReference.Default.UcConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ReportIncidentDSTableAdapter" GeneratorDataComponentClassName="ReportIncidentDSTableAdapter" Name="ReportIncidentDS" UserDataComponentName="ReportIncidentDSTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="UcConnectionString (Settings)" DbObjectName="UC_WEB.dbo.usp_report_incident" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.usp_report_incident</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@date_start" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@date_end" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="incident_id" DataSetColumn="incident_id" />
              <Mapping SourceColumn="subject" DataSetColumn="subject" />
              <Mapping SourceColumn="date_created" DataSetColumn="date_created" />
              <Mapping SourceColumn="date_open" DataSetColumn="date_open" />
              <Mapping SourceColumn="date_closed" DataSetColumn="date_closed" />
              <Mapping SourceColumn="date_updated" DataSetColumn="date_updated" />
              <Mapping SourceColumn="date_deleted" DataSetColumn="date_deleted" />
              <Mapping SourceColumn="incident_status_name" DataSetColumn="incident_status_name" />
              <Mapping SourceColumn="group_name" DataSetColumn="group_name" />
              <Mapping SourceColumn="agent_first_name" DataSetColumn="agent_first_name" />
              <Mapping SourceColumn="agent_last_name" DataSetColumn="agent_last_name" />
              <Mapping SourceColumn="contact_first_name" DataSetColumn="contact_first_name" />
              <Mapping SourceColumn="contact_last_name" DataSetColumn="contact_last_name" />
              <Mapping SourceColumn="facility_name" DataSetColumn="facility_name" />
              <Mapping SourceColumn="agent_full_name" DataSetColumn="agent_full_name" />
              <Mapping SourceColumn="contact_full_name" DataSetColumn="contact_full_name" />
              <Mapping SourceColumn="duration" DataSetColumn="duration" />
              <Mapping SourceColumn="date" DataSetColumn="date" />
              <Mapping SourceColumn="time" DataSetColumn="time" />
              <Mapping SourceColumn="group_field" DataSetColumn="group_field" />
              <Mapping SourceColumn="group_field_title" DataSetColumn="group_field_title" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ReportSurveyDSTableAdapter" GeneratorDataComponentClassName="ReportSurveyDSTableAdapter" Name="ReportSurveyDS" UserDataComponentName="ReportSurveyDSTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="UcConnectionString (Settings)" DbObjectName="UC_WEB.dbo.usp_report_survey" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.usp_report_survey</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@date_start" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@date_end" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="contact_full_name" DataSetColumn="contact_full_name" />
              <Mapping SourceColumn="agent_full_name" DataSetColumn="agent_full_name" />
              <Mapping SourceColumn="group_field" DataSetColumn="group_field" />
              <Mapping SourceColumn="survey_response_id" DataSetColumn="survey_response_id" />
              <Mapping SourceColumn="incident_id" DataSetColumn="incident_id" />
              <Mapping SourceColumn="subject" DataSetColumn="subject" />
              <Mapping SourceColumn="date_open" DataSetColumn="date_open" />
              <Mapping SourceColumn="incident_status_name" DataSetColumn="incident_status_name" />
              <Mapping SourceColumn="group_name" DataSetColumn="group_name" />
              <Mapping SourceColumn="agent_first_name" DataSetColumn="agent_first_name" />
              <Mapping SourceColumn="agent_last_name" DataSetColumn="agent_last_name" />
              <Mapping SourceColumn="contact_first_name" DataSetColumn="contact_first_name" />
              <Mapping SourceColumn="contact_last_name" DataSetColumn="contact_last_name" />
              <Mapping SourceColumn="facility_name" DataSetColumn="facility_name" />
              <Mapping SourceColumn="survey_name" DataSetColumn="survey_name" />
              <Mapping SourceColumn="question_text" DataSetColumn="question_text" />
              <Mapping SourceColumn="response" DataSetColumn="response" />
              <Mapping SourceColumn="time" DataSetColumn="time" />
              <Mapping SourceColumn="date" DataSetColumn="date" />
              <Mapping SourceColumn="duration" DataSetColumn="duration" />
              <Mapping SourceColumn="date_closed" DataSetColumn="date_closed" />
              <Mapping SourceColumn="date_survey_created" DataSetColumn="date_survey_created" />
              <Mapping SourceColumn="group_field_title" DataSetColumn="group_field_title" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ReportSurveyAverageTableAdapter" GeneratorDataComponentClassName="ReportSurveyAverageTableAdapter" Name="ReportSurveyAverage" UserDataComponentName="ReportSurveyAverageTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="UcConnectionString (Settings)" DbObjectName="UC_WEB.dbo.usp_report_survey_average" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.usp_report_survey_average</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@date_start" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@date_end" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="incident_id" DataSetColumn="incident_id" />
              <Mapping SourceColumn="survey_id" DataSetColumn="survey_id" />
              <Mapping SourceColumn="question_id" DataSetColumn="question_id" />
              <Mapping SourceColumn="survey_response_id" DataSetColumn="survey_response_id" />
              <Mapping SourceColumn="date_open" DataSetColumn="date_open" />
              <Mapping SourceColumn="date_closed" DataSetColumn="date_closed" />
              <Mapping SourceColumn="incident_status_name" DataSetColumn="incident_status_name" />
              <Mapping SourceColumn="group_name" DataSetColumn="group_name" />
              <Mapping SourceColumn="agent_first_name" DataSetColumn="agent_first_name" />
              <Mapping SourceColumn="agent_last_name" DataSetColumn="agent_last_name" />
              <Mapping SourceColumn="contact_first_name" DataSetColumn="contact_first_name" />
              <Mapping SourceColumn="contact_last_name" DataSetColumn="contact_last_name" />
              <Mapping SourceColumn="facility_name" DataSetColumn="facility_name" />
              <Mapping SourceColumn="date_survey_created" DataSetColumn="date_survey_created" />
              <Mapping SourceColumn="survey_name" DataSetColumn="survey_name" />
              <Mapping SourceColumn="question_text" DataSetColumn="question_text" />
              <Mapping SourceColumn="response" DataSetColumn="response" />
              <Mapping SourceColumn="agent_full_name" DataSetColumn="agent_full_name" />
              <Mapping SourceColumn="contact_full_name" DataSetColumn="contact_full_name" />
              <Mapping SourceColumn="date" DataSetColumn="date" />
              <Mapping SourceColumn="time" DataSetColumn="time" />
              <Mapping SourceColumn="duration" DataSetColumn="duration" />
              <Mapping SourceColumn="group_field" DataSetColumn="group_field" />
              <Mapping SourceColumn="group_field_title" DataSetColumn="group_field_title" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="ReportDS" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="ReportDS" msprop:Generator_DataSetName="ReportDS" msprop:EnableTableAdapterManager="true">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="ReportIncidentDS" msprop:Generator_UserTableName="ReportIncidentDS" msprop:Generator_RowDeletedName="ReportIncidentDSRowDeleted" msprop:Generator_RowChangedName="ReportIncidentDSRowChanged" msprop:Generator_RowClassName="ReportIncidentDSRow" msprop:Generator_RowChangingName="ReportIncidentDSRowChanging" msprop:Generator_RowEvArgName="ReportIncidentDSRowChangeEvent" msprop:Generator_RowEvHandlerName="ReportIncidentDSRowChangeEventHandler" msprop:Generator_TableClassName="ReportIncidentDSDataTable" msprop:Generator_TableVarName="tableReportIncidentDS" msprop:Generator_RowDeletingName="ReportIncidentDSRowDeleting" msprop:Generator_TablePropName="ReportIncidentDS">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="incident_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="incident_id" msprop:Generator_ColumnPropNameInRow="incident_id" msprop:Generator_ColumnVarNameInTable="columnincident_id" msprop:Generator_ColumnPropNameInTable="incident_idColumn" type="xs:int" />
              <xs:element name="subject" msprop:Generator_UserColumnName="subject" msprop:Generator_ColumnPropNameInRow="subject" msprop:Generator_ColumnVarNameInTable="columnsubject" msprop:Generator_ColumnPropNameInTable="subjectColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="date_created" msprop:Generator_UserColumnName="date_created" msprop:Generator_ColumnPropNameInRow="date_created" msprop:Generator_ColumnVarNameInTable="columndate_created" msprop:Generator_ColumnPropNameInTable="date_createdColumn" type="xs:dateTime" />
              <xs:element name="date_open" msprop:Generator_UserColumnName="date_open" msprop:Generator_ColumnPropNameInRow="date_open" msprop:Generator_ColumnVarNameInTable="columndate_open" msprop:Generator_ColumnPropNameInTable="date_openColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="date_closed" msprop:Generator_UserColumnName="date_closed" msprop:Generator_ColumnPropNameInRow="date_closed" msprop:Generator_ColumnVarNameInTable="columndate_closed" msprop:Generator_ColumnPropNameInTable="date_closedColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="date_updated" msprop:Generator_UserColumnName="date_updated" msprop:Generator_ColumnPropNameInRow="date_updated" msprop:Generator_ColumnVarNameInTable="columndate_updated" msprop:Generator_ColumnPropNameInTable="date_updatedColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="date_deleted" msprop:Generator_UserColumnName="date_deleted" msprop:Generator_ColumnPropNameInRow="date_deleted" msprop:Generator_ColumnVarNameInTable="columndate_deleted" msprop:Generator_ColumnPropNameInTable="date_deletedColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="incident_status_name" msprop:Generator_UserColumnName="incident_status_name" msprop:Generator_ColumnPropNameInRow="incident_status_name" msprop:Generator_ColumnVarNameInTable="columnincident_status_name" msprop:Generator_ColumnPropNameInTable="incident_status_nameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="group_name" msprop:Generator_UserColumnName="group_name" msprop:nullValue="_null" msprop:Generator_ColumnVarNameInTable="columngroup_name" msprop:Generator_ColumnPropNameInTable="group_nameColumn" msprop:Generator_ColumnPropNameInRow="group_name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="agent_first_name" msprop:Generator_UserColumnName="agent_first_name" msprop:nullValue="_null" msprop:Generator_ColumnPropNameInRow="agent_first_name" msprop:Generator_ColumnPropNameInTable="agent_first_nameColumn" msprop:Generator_ColumnVarNameInTable="columnagent_first_name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="agent_last_name" msprop:Generator_UserColumnName="agent_last_name" msprop:nullValue="_null" msprop:Generator_ColumnPropNameInRow="agent_last_name" msprop:Generator_ColumnPropNameInTable="agent_last_nameColumn" msprop:Generator_ColumnVarNameInTable="columnagent_last_name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="contact_first_name" msprop:Generator_UserColumnName="contact_first_name" msprop:nullValue="_null" msprop:Generator_ColumnPropNameInRow="contact_first_name" msprop:Generator_ColumnPropNameInTable="contact_first_nameColumn" msprop:Generator_ColumnVarNameInTable="columncontact_first_name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="contact_last_name" msprop:Generator_UserColumnName="contact_last_name" msprop:nullValue="_null" msprop:Generator_ColumnPropNameInRow="contact_last_name" msprop:Generator_ColumnPropNameInTable="contact_last_nameColumn" msprop:Generator_ColumnVarNameInTable="columncontact_last_name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="facility_name" msprop:Generator_UserColumnName="facility_name" msprop:nullValue="_null" msprop:Generator_ColumnPropNameInRow="facility_name" msprop:Generator_ColumnPropNameInTable="facility_nameColumn" msprop:Generator_ColumnVarNameInTable="columnfacility_name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="agent_full_name" msprop:Generator_UserColumnName="agent_full_name" msprop:nullValue="_null" msprop:Generator_ColumnPropNameInRow="agent_full_name" msprop:Generator_ColumnPropNameInTable="agent_full_nameColumn" msprop:Generator_ColumnVarNameInTable="columnagent_full_name" type="xs:string" minOccurs="0" />
              <xs:element name="contact_full_name" msprop:Generator_UserColumnName="contact_full_name" msprop:nullValue="_null" msprop:Generator_ColumnPropNameInRow="contact_full_name" msprop:Generator_ColumnPropNameInTable="contact_full_nameColumn" msprop:Generator_ColumnVarNameInTable="columncontact_full_name" type="xs:string" minOccurs="0" />
              <xs:element name="duration" msprop:Generator_UserColumnName="duration" msprop:nullValue="_null" msprop:Generator_ColumnVarNameInTable="columnduration" msprop:Generator_ColumnPropNameInTable="durationColumn" msprop:Generator_ColumnPropNameInRow="duration" type="xs:string" minOccurs="0" />
              <xs:element name="group_field" msprop:Generator_UserColumnName="group_field" msprop:nullValue="_null" msprop:Generator_ColumnVarNameInTable="columngroup_field" msprop:Generator_ColumnPropNameInTable="group_fieldColumn" msprop:Generator_ColumnPropNameInRow="group_field" type="xs:string" minOccurs="0" />
              <xs:element name="date" msprop:Generator_UserColumnName="date" msprop:nullValue="_null" msprop:Generator_ColumnVarNameInTable="columndate" msprop:Generator_ColumnPropNameInTable="dateColumn" msprop:Generator_ColumnPropNameInRow="date" type="xs:string" minOccurs="0" />
              <xs:element name="time" msprop:Generator_UserColumnName="time" msprop:nullValue="_null" msprop:Generator_ColumnVarNameInTable="columntime" msprop:Generator_ColumnPropNameInTable="timeColumn" msprop:Generator_ColumnPropNameInRow="time" type="xs:string" minOccurs="0" />
              <xs:element name="group_field_title" msprop:Generator_UserColumnName="group_field_title" msprop:Generator_ColumnPropNameInRow="group_field_title" msprop:nullValue="_null" msprop:Generator_ColumnVarNameInTable="columngroup_field_title" msprop:Generator_ColumnPropNameInTable="group_field_titleColumn" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ReportSurveyDS" msprop:Generator_UserTableName="ReportSurveyDS" msprop:Generator_RowDeletedName="ReportSurveyDSRowDeleted" msprop:Generator_RowChangedName="ReportSurveyDSRowChanged" msprop:Generator_RowClassName="ReportSurveyDSRow" msprop:Generator_RowChangingName="ReportSurveyDSRowChanging" msprop:Generator_RowEvArgName="ReportSurveyDSRowChangeEvent" msprop:Generator_RowEvHandlerName="ReportSurveyDSRowChangeEventHandler" msprop:Generator_TableClassName="ReportSurveyDSDataTable" msprop:Generator_TableVarName="tableReportSurveyDS" msprop:Generator_RowDeletingName="ReportSurveyDSRowDeleting" msprop:Generator_TablePropName="ReportSurveyDS">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="agent_full_name" msprop:Generator_UserColumnName="agent_full_name" msprop:nullValue="_null" msprop:Generator_ColumnVarNameInTable="columnagent_full_name" msprop:Generator_ColumnPropNameInTable="agent_full_nameColumn" msprop:Generator_ColumnPropNameInRow="agent_full_name" type="xs:string" minOccurs="0" />
              <xs:element name="contact_full_name" msprop:Generator_UserColumnName="contact_full_name" msprop:nullValue="_null" msprop:Generator_ColumnVarNameInTable="columncontact_full_name" msprop:Generator_ColumnPropNameInTable="contact_full_nameColumn" msprop:Generator_ColumnPropNameInRow="contact_full_name" type="xs:string" minOccurs="0" />
              <xs:element name="group_field" msprop:Generator_UserColumnName="group_field" msprop:nullValue="_null" msprop:Generator_ColumnVarNameInTable="columngroup_field" msprop:Generator_ColumnPropNameInTable="group_fieldColumn" msprop:Generator_ColumnPropNameInRow="group_field" type="xs:string" minOccurs="0" />
              <xs:element name="survey_response_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="survey_response_id" msprop:Generator_ColumnVarNameInTable="columnsurvey_response_id" msprop:Generator_ColumnPropNameInRow="survey_response_id" msprop:Generator_ColumnPropNameInTable="survey_response_idColumn" type="xs:int" />
              <xs:element name="incident_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="incident_id" msprop:Generator_ColumnVarNameInTable="columnincident_id" msprop:Generator_ColumnPropNameInRow="incident_id" msprop:Generator_ColumnPropNameInTable="incident_idColumn" type="xs:int" />
              <xs:element name="subject" msprop:Generator_UserColumnName="subject" msprop:Generator_ColumnVarNameInTable="columnsubject" msprop:Generator_ColumnPropNameInRow="subject" msprop:Generator_ColumnPropNameInTable="subjectColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="date_open" msprop:Generator_UserColumnName="date_open" msprop:Generator_ColumnVarNameInTable="columndate_open" msprop:Generator_ColumnPropNameInRow="date_open" msprop:Generator_ColumnPropNameInTable="date_openColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="incident_status_name" msprop:Generator_UserColumnName="incident_status_name" msprop:Generator_ColumnVarNameInTable="columnincident_status_name" msprop:Generator_ColumnPropNameInRow="incident_status_name" msprop:Generator_ColumnPropNameInTable="incident_status_nameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="group_name" msprop:Generator_UserColumnName="group_name" msprop:nullValue="_null" msprop:Generator_ColumnPropNameInRow="group_name" msprop:Generator_ColumnPropNameInTable="group_nameColumn" msprop:Generator_ColumnVarNameInTable="columngroup_name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="agent_first_name" msprop:Generator_UserColumnName="agent_first_name" msprop:nullValue="_null" msprop:Generator_ColumnVarNameInTable="columnagent_first_name" msprop:Generator_ColumnPropNameInTable="agent_first_nameColumn" msprop:Generator_ColumnPropNameInRow="agent_first_name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="agent_last_name" msprop:Generator_UserColumnName="agent_last_name" msprop:nullValue="_null" msprop:Generator_ColumnVarNameInTable="columnagent_last_name" msprop:Generator_ColumnPropNameInTable="agent_last_nameColumn" msprop:Generator_ColumnPropNameInRow="agent_last_name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="contact_first_name" msprop:Generator_UserColumnName="contact_first_name" msprop:nullValue="_null" msprop:Generator_ColumnVarNameInTable="columncontact_first_name" msprop:Generator_ColumnPropNameInTable="contact_first_nameColumn" msprop:Generator_ColumnPropNameInRow="contact_first_name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="contact_last_name" msprop:Generator_UserColumnName="contact_last_name" msprop:nullValue="_null" msprop:Generator_ColumnVarNameInTable="columncontact_last_name" msprop:Generator_ColumnPropNameInTable="contact_last_nameColumn" msprop:Generator_ColumnPropNameInRow="contact_last_name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="facility_name" msprop:Generator_UserColumnName="facility_name" msprop:nullValue="_null" msprop:Generator_ColumnVarNameInTable="columnfacility_name" msprop:Generator_ColumnPropNameInTable="facility_nameColumn" msprop:Generator_ColumnPropNameInRow="facility_name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="survey_name" msprop:Generator_UserColumnName="survey_name" msprop:Generator_ColumnVarNameInTable="columnsurvey_name" msprop:Generator_ColumnPropNameInRow="survey_name" msprop:Generator_ColumnPropNameInTable="survey_nameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="question_text" msprop:Generator_UserColumnName="question_text" msprop:Generator_ColumnVarNameInTable="columnquestion_text" msprop:Generator_ColumnPropNameInRow="question_text" msprop:Generator_ColumnPropNameInTable="question_textColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="response" msprop:Generator_UserColumnName="response" msprop:nullValue="_null" msprop:Generator_ColumnPropNameInRow="response" msprop:Generator_ColumnPropNameInTable="responseColumn" msprop:Generator_ColumnVarNameInTable="columnresponse" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="date" msprop:Generator_UserColumnName="date" msprop:nullValue="_null" msprop:Generator_ColumnVarNameInTable="columndate" msprop:Generator_ColumnPropNameInTable="dateColumn" msprop:Generator_ColumnPropNameInRow="date" type="xs:string" minOccurs="0" />
              <xs:element name="time" msprop:Generator_UserColumnName="time" msprop:nullValue="_null" msprop:Generator_ColumnVarNameInTable="columntime" msprop:Generator_ColumnPropNameInTable="timeColumn" msprop:Generator_ColumnPropNameInRow="time" type="xs:string" minOccurs="0" />
              <xs:element name="duration" msprop:Generator_UserColumnName="duration" msprop:nullValue="_null" msprop:Generator_ColumnVarNameInTable="columnduration" msprop:Generator_ColumnPropNameInTable="durationColumn" msprop:Generator_ColumnPropNameInRow="duration" type="xs:string" minOccurs="0" />
              <xs:element name="date_closed" msprop:Generator_UserColumnName="date_closed" msprop:Generator_ColumnVarNameInTable="columndate_closed" msprop:Generator_ColumnPropNameInRow="date_closed" msprop:Generator_ColumnPropNameInTable="date_closedColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="date_survey_created" msprop:Generator_UserColumnName="date_survey_created" msprop:Generator_ColumnPropNameInRow="date_survey_created" msprop:Generator_ColumnVarNameInTable="columndate_survey_created" msprop:Generator_ColumnPropNameInTable="date_survey_createdColumn" type="xs:dateTime" />
              <xs:element name="group_field_title" msprop:Generator_UserColumnName="group_field_title" msprop:nullValue="_null" msprop:Generator_ColumnVarNameInTable="columngroup_field_title" msprop:Generator_ColumnPropNameInTable="group_field_titleColumn" msprop:Generator_ColumnPropNameInRow="group_field_title" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ReportSurveyAverage" msprop:Generator_UserTableName="ReportSurveyAverage" msprop:Generator_RowDeletedName="ReportSurveyAverageRowDeleted" msprop:Generator_RowChangedName="ReportSurveyAverageRowChanged" msprop:Generator_RowClassName="ReportSurveyAverageRow" msprop:Generator_RowChangingName="ReportSurveyAverageRowChanging" msprop:Generator_RowEvArgName="ReportSurveyAverageRowChangeEvent" msprop:Generator_RowEvHandlerName="ReportSurveyAverageRowChangeEventHandler" msprop:Generator_TableClassName="ReportSurveyAverageDataTable" msprop:Generator_TableVarName="tableReportSurveyAverage" msprop:Generator_RowDeletingName="ReportSurveyAverageRowDeleting" msprop:Generator_TablePropName="ReportSurveyAverage">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="incident_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="incident_id" msprop:Generator_ColumnPropNameInRow="incident_id" msprop:Generator_ColumnVarNameInTable="columnincident_id" msprop:Generator_ColumnPropNameInTable="incident_idColumn" type="xs:int" />
              <xs:element name="survey_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="survey_id" msprop:Generator_ColumnPropNameInRow="survey_id" msprop:Generator_ColumnVarNameInTable="columnsurvey_id" msprop:Generator_ColumnPropNameInTable="survey_idColumn" type="xs:int" />
              <xs:element name="question_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="question_id" msprop:Generator_ColumnPropNameInRow="question_id" msprop:Generator_ColumnVarNameInTable="columnquestion_id" msprop:Generator_ColumnPropNameInTable="question_idColumn" type="xs:int" />
              <xs:element name="survey_response_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="survey_response_id" msprop:Generator_ColumnPropNameInRow="survey_response_id" msprop:Generator_ColumnVarNameInTable="columnsurvey_response_id" msprop:Generator_ColumnPropNameInTable="survey_response_idColumn" type="xs:int" />
              <xs:element name="date_open" msprop:Generator_UserColumnName="date_open" msprop:Generator_ColumnPropNameInRow="date_open" msprop:Generator_ColumnVarNameInTable="columndate_open" msprop:Generator_ColumnPropNameInTable="date_openColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="date_closed" msprop:Generator_UserColumnName="date_closed" msprop:Generator_ColumnPropNameInRow="date_closed" msprop:Generator_ColumnVarNameInTable="columndate_closed" msprop:Generator_ColumnPropNameInTable="date_closedColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="incident_status_name" msprop:Generator_UserColumnName="incident_status_name" msprop:Generator_ColumnPropNameInRow="incident_status_name" msprop:Generator_ColumnVarNameInTable="columnincident_status_name" msprop:Generator_ColumnPropNameInTable="incident_status_nameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="group_name" msprop:Generator_UserColumnName="group_name" msprop:nullValue="_null" msprop:Generator_ColumnPropNameInRow="group_name" msprop:Generator_ColumnPropNameInTable="group_nameColumn" msprop:Generator_ColumnVarNameInTable="columngroup_name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="agent_first_name" msprop:Generator_UserColumnName="agent_first_name" msprop:nullValue="_null" msprop:Generator_ColumnPropNameInRow="agent_first_name" msprop:Generator_ColumnPropNameInTable="agent_first_nameColumn" msprop:Generator_ColumnVarNameInTable="columnagent_first_name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="agent_last_name" msprop:Generator_UserColumnName="agent_last_name" msprop:nullValue="_null" msprop:Generator_ColumnPropNameInRow="agent_last_name" msprop:Generator_ColumnPropNameInTable="agent_last_nameColumn" msprop:Generator_ColumnVarNameInTable="columnagent_last_name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="contact_first_name" msprop:Generator_UserColumnName="contact_first_name" msprop:nullValue="_null" msprop:Generator_ColumnPropNameInRow="contact_first_name" msprop:Generator_ColumnPropNameInTable="contact_first_nameColumn" msprop:Generator_ColumnVarNameInTable="columncontact_first_name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="contact_last_name" msprop:Generator_UserColumnName="contact_last_name" msprop:nullValue="_null" msprop:Generator_ColumnPropNameInRow="contact_last_name" msprop:Generator_ColumnPropNameInTable="contact_last_nameColumn" msprop:Generator_ColumnVarNameInTable="columncontact_last_name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="facility_name" msprop:Generator_UserColumnName="facility_name" msprop:nullValue="_null" msprop:Generator_ColumnPropNameInRow="facility_name" msprop:Generator_ColumnPropNameInTable="facility_nameColumn" msprop:Generator_ColumnVarNameInTable="columnfacility_name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="date_survey_created" msprop:Generator_UserColumnName="date_survey_created" msprop:Generator_ColumnPropNameInRow="date_survey_created" msprop:Generator_ColumnVarNameInTable="columndate_survey_created" msprop:Generator_ColumnPropNameInTable="date_survey_createdColumn" type="xs:dateTime" />
              <xs:element name="survey_name" msprop:Generator_UserColumnName="survey_name" msprop:Generator_ColumnPropNameInRow="survey_name" msprop:Generator_ColumnVarNameInTable="columnsurvey_name" msprop:Generator_ColumnPropNameInTable="survey_nameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="question_text" msprop:Generator_UserColumnName="question_text" msprop:Generator_ColumnPropNameInRow="question_text" msprop:Generator_ColumnVarNameInTable="columnquestion_text" msprop:Generator_ColumnPropNameInTable="question_textColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="response" msprop:Generator_UserColumnName="response" msprop:nullValue="_null" msprop:Generator_ColumnVarNameInTable="columnresponse" msprop:Generator_ColumnPropNameInTable="responseColumn" msprop:Generator_ColumnPropNameInRow="response" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="agent_full_name" msprop:Generator_UserColumnName="agent_full_name" msprop:nullValue="_null" msprop:Generator_ColumnPropNameInRow="agent_full_name" msprop:Generator_ColumnPropNameInTable="agent_full_nameColumn" msprop:Generator_ColumnVarNameInTable="columnagent_full_name" type="xs:string" minOccurs="0" />
              <xs:element name="contact_full_name" msprop:Generator_UserColumnName="contact_full_name" msprop:nullValue="_null" msprop:Generator_ColumnPropNameInRow="contact_full_name" msprop:Generator_ColumnPropNameInTable="contact_full_nameColumn" msprop:Generator_ColumnVarNameInTable="columncontact_full_name" type="xs:string" minOccurs="0" />
              <xs:element name="date" msprop:Generator_UserColumnName="date" msprop:nullValue="_null" msprop:Generator_ColumnPropNameInRow="date" msprop:Generator_ColumnPropNameInTable="dateColumn" msprop:Generator_ColumnVarNameInTable="columndate" type="xs:string" minOccurs="0" />
              <xs:element name="time" msprop:Generator_UserColumnName="time" msprop:nullValue="_null" msprop:Generator_ColumnPropNameInRow="time" msprop:Generator_ColumnPropNameInTable="timeColumn" msprop:Generator_ColumnVarNameInTable="columntime" type="xs:string" minOccurs="0" />
              <xs:element name="duration" msprop:Generator_UserColumnName="duration" msprop:nullValue="_null" msprop:Generator_ColumnPropNameInRow="duration" msprop:Generator_ColumnPropNameInTable="durationColumn" msprop:Generator_ColumnVarNameInTable="columnduration" type="xs:string" minOccurs="0" />
              <xs:element name="group_field" msprop:Generator_UserColumnName="group_field" msprop:nullValue="_null" msprop:Generator_ColumnVarNameInTable="columngroup_field" msprop:Generator_ColumnPropNameInTable="group_fieldColumn" msprop:Generator_ColumnPropNameInRow="group_field" type="xs:string" minOccurs="0" />
              <xs:element name="group_field_title" msprop:Generator_UserColumnName="group_field_title" msprop:nullValue="_null" msprop:Generator_ColumnVarNameInTable="columngroup_field_title" msprop:Generator_ColumnPropNameInTable="group_field_titleColumn" msprop:Generator_ColumnPropNameInRow="group_field_title" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ReportIncidentDS" />
      <xs:field xpath="mstns:incident_id" />
    </xs:unique>
  </xs:element>
</xs:schema>